github.com/turbot/steampipe@v1.7.0-rc.0.0.20240517123944-7cef272d4458/tests/manual_testing/many controls/queries/q19.sql (about)

     1  select
     2      -- Required Columns
     3      'arn:' || partition || ':apigateway:' || region || '::/apis/' || rest_api_id || '/stages/' as resource,
     4      case
     5          when client_certificate_id is null then 'alarm'
     6          else 'ok'
     7          end as status,
     8      case
     9          when client_certificate_id is null then title || ' not uses SSL certificate.'
    10          else title || ' uses SSL certificate.'
    11          end as reason,
    12      -- Additional Dimensions
    13      region,
    14      account_id
    15  from
    16      aws_api_gateway_stage;